{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e578e5ed-d47b-4604-9530-709a7218d084",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "79eed29b-a343-4de8-874e-0a95a936b177",
   "metadata": {},
   "outputs": [],
   "source": [
    "data=pd.read_excel('result2.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a8733ec2-7560-472d-b74b-d14097f14231",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=data['适用人群']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f41f3b3e-49ec-437e-8376-192ff53d789e",
   "metadata": {},
   "outputs": [],
   "source": [
    "（1）客户1：婴儿、蛋白质过敏。 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "f7647593-f8cc-4644-9c0c-b504dfabc0c8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>企业名称</th>\n",
       "      <th>产品名称</th>\n",
       "      <th>注册证号</th>\n",
       "      <th>有效期至</th>\n",
       "      <th>产品类别</th>\n",
       "      <th>组织状态</th>\n",
       "      <th>适用人群</th>\n",
       "      <th>适用人群类别</th>\n",
       "      <th>产品来源</th>\n",
       "      <th>登记年份</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>SHS INTERNATIONAL LTD</td>\n",
       "      <td>纽康特特殊医学用途婴儿氨基酸配方食品</td>\n",
       "      <td>国食注字TY20175001</td>\n",
       "      <td>2027-10-13</td>\n",
       "      <td>氨基酸配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>食物蛋白过敏婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>ABBOTT LABORATORIES S.A.</td>\n",
       "      <td>雅培亲护特殊医学用途婴儿乳蛋白部分水解配方粉</td>\n",
       "      <td>国食注字TY20175002</td>\n",
       "      <td>2027-10-13</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>ABBOTT LABORATORIES S.A.</td>\n",
       "      <td>菁挚呵护特殊医学用途婴儿乳蛋白部分水解配方粉</td>\n",
       "      <td>国食注字TY20175003</td>\n",
       "      <td>2022-11-19</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0-12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>MEAD JOHNSON B.V.</td>\n",
       "      <td>亲舒特殊医学用途婴儿乳蛋白部分水解配方粉</td>\n",
       "      <td>国食注字TY20185002</td>\n",
       "      <td>2028-01-17</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>圣元营养食品有限公司</td>\n",
       "      <td>优博敏佳特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20180004</td>\n",
       "      <td>2023-08-13</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>NESTLE NEDERLAND B.V.</td>\n",
       "      <td>蔼儿舒特殊医学用途婴儿乳蛋白深度水解配方食品</td>\n",
       "      <td>国食注字TY20185012</td>\n",
       "      <td>2028-11-28</td>\n",
       "      <td>乳蛋白深度水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄食物蛋白过敏婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Nestlé Deutschland AG</td>\n",
       "      <td>超启能恩特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20195002</td>\n",
       "      <td>2029-01-21</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>Nestle Nederland B.V.</td>\n",
       "      <td>肽敏舒ALTHÉRA®特殊医学用途婴儿乳蛋白深度水解配方食品</td>\n",
       "      <td>国食注字TY20195010</td>\n",
       "      <td>2024-10-21</td>\n",
       "      <td>乳蛋白深度水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄食物蛋白过敏婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>44</td>\n",
       "      <td>杭州贝因美母婴营养品有限公司</td>\n",
       "      <td>舒力乐特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20200006</td>\n",
       "      <td>2025-05-13</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>46</td>\n",
       "      <td>Nestle Nederland B.V.</td>\n",
       "      <td>恩敏舒特殊医学用途婴儿氨基酸配方食品</td>\n",
       "      <td>国食注字TY20205001</td>\n",
       "      <td>2025-05-15</td>\n",
       "      <td>氨基酸配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄食物蛋白过敏婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>96</td>\n",
       "      <td>Nutricia Cuijk B.V.</td>\n",
       "      <td>纽太特特殊医学用途婴儿乳蛋白深度水解配方食品</td>\n",
       "      <td>国食注字TY20235001</td>\n",
       "      <td>2028-02-09</td>\n",
       "      <td>乳蛋白深度水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄食物蛋白过敏婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>119</td>\n",
       "      <td>青岛圣桐营养食品有限公司</td>\n",
       "      <td>特爱敏佳特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20230029</td>\n",
       "      <td>2028-06-15</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>135</td>\n",
       "      <td>雀巢德国有限公司</td>\n",
       "      <td>启赋®敏适特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20235002</td>\n",
       "      <td>2028-08-28</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>150</td>\n",
       "      <td>北安宜品努卡乳业有限公司</td>\n",
       "      <td>宜品怡贝特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20230059</td>\n",
       "      <td>2028-11-13</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>168</td>\n",
       "      <td>纽迪希亚库克有限责任公司</td>\n",
       "      <td>爱他美亲熠特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20245001</td>\n",
       "      <td>2029-01-05</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>进口产品</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>173</td>\n",
       "      <td>石家庄君乐宝太行乳业有限公司</td>\n",
       "      <td>恬适康敏特殊医学用途婴儿乳蛋白部分水解配方食品</td>\n",
       "      <td>国食注字TY20240013</td>\n",
       "      <td>2029-02-08</td>\n",
       "      <td>乳蛋白部分水解配方</td>\n",
       "      <td>粉状</td>\n",
       "      <td>0～12月龄乳蛋白过敏高风险婴儿</td>\n",
       "      <td>特医婴配食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                      企业名称                            产品名称  \\\n",
       "0             0     SHS INTERNATIONAL LTD              纽康特特殊医学用途婴儿氨基酸配方食品   \n",
       "1             1  ABBOTT LABORATORIES S.A.          雅培亲护特殊医学用途婴儿乳蛋白部分水解配方粉   \n",
       "2             2  ABBOTT LABORATORIES S.A.          菁挚呵护特殊医学用途婴儿乳蛋白部分水解配方粉   \n",
       "5             5         MEAD JOHNSON B.V.            亲舒特殊医学用途婴儿乳蛋白部分水解配方粉   \n",
       "13           13                圣元营养食品有限公司         优博敏佳特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "17           17     NESTLE NEDERLAND B.V.          蔼儿舒特殊医学用途婴儿乳蛋白深度水解配方食品   \n",
       "20           20     Nestlé Deutschland AG         超启能恩特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "36           36     Nestle Nederland B.V.  肽敏舒ALTHÉRA®特殊医学用途婴儿乳蛋白深度水解配方食品   \n",
       "44           44            杭州贝因美母婴营养品有限公司          舒力乐特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "46           46     Nestle Nederland B.V.              恩敏舒特殊医学用途婴儿氨基酸配方食品   \n",
       "96           96       Nutricia Cuijk B.V.          纽太特特殊医学用途婴儿乳蛋白深度水解配方食品   \n",
       "119         119              青岛圣桐营养食品有限公司         特爱敏佳特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "135         135                  雀巢德国有限公司        启赋®敏适特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "150         150              北安宜品努卡乳业有限公司         宜品怡贝特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "168         168              纽迪希亚库克有限责任公司        爱他美亲熠特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "173         173            石家庄君乐宝太行乳业有限公司         恬适康敏特殊医学用途婴儿乳蛋白部分水解配方食品   \n",
       "\n",
       "               注册证号       有效期至       产品类别 组织状态              适用人群  适用人群类别  \\\n",
       "0    国食注字TY20175001 2027-10-13      氨基酸配方   粉状          食物蛋白过敏婴儿  特医婴配食品   \n",
       "1    国食注字TY20175002 2027-10-13  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "2    国食注字TY20175003 2022-11-19  乳蛋白部分水解配方   粉状  0-12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "5    国食注字TY20185002 2028-01-17  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "13   国食注字TY20180004 2023-08-13  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "17   国食注字TY20185012 2028-11-28  乳蛋白深度水解配方   粉状    0～12月龄食物蛋白过敏婴儿  特医婴配食品   \n",
       "20   国食注字TY20195002 2029-01-21  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "36   国食注字TY20195010 2024-10-21  乳蛋白深度水解配方   粉状    0～12月龄食物蛋白过敏婴儿  特医婴配食品   \n",
       "44   国食注字TY20200006 2025-05-13  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "46   国食注字TY20205001 2025-05-15      氨基酸配方   粉状    0～12月龄食物蛋白过敏婴儿  特医婴配食品   \n",
       "96   国食注字TY20235001 2028-02-09  乳蛋白深度水解配方   粉状    0～12月龄食物蛋白过敏婴儿  特医婴配食品   \n",
       "119  国食注字TY20230029 2028-06-15  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "135  国食注字TY20235002 2028-08-28  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "150  国食注字TY20230059 2028-11-13  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "168  国食注字TY20245001 2029-01-05  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "173  国食注字TY20240013 2029-02-08  乳蛋白部分水解配方   粉状  0～12月龄乳蛋白过敏高风险婴儿  特医婴配食品   \n",
       "\n",
       "     产品来源  登记年份  \n",
       "0    进口产品  2017  \n",
       "1    进口产品  2017  \n",
       "2    进口产品  2017  \n",
       "5    进口产品  2018  \n",
       "13   国产产品  2018  \n",
       "17   进口产品  2018  \n",
       "20   进口产品  2019  \n",
       "36   进口产品  2019  \n",
       "44   国产产品  2020  \n",
       "46   进口产品  2020  \n",
       "96   进口产品  2023  \n",
       "119  国产产品  2023  \n",
       "135  进口产品  2023  \n",
       "150  国产产品  2023  \n",
       "168  进口产品  2024  \n",
       "173  国产产品  2024  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(df.str.contains('婴儿'))&(df.str.contains('蛋白过敏'))]"
   ]
  },
  {
   "cell_type": "raw",
   "id": "f0271a89-5bbc-4817-acf3-da2dce495b43",
   "metadata": {},
   "source": [
    "（2）客户2：10岁儿童、需要补充蛋白质、乳糖不耐受。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f68842bd-8955-4d73-b79d-64917dc55498",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>企业名称</th>\n",
       "      <th>产品名称</th>\n",
       "      <th>注册证号</th>\n",
       "      <th>有效期至</th>\n",
       "      <th>产品类别</th>\n",
       "      <th>组织状态</th>\n",
       "      <th>适用人群</th>\n",
       "      <th>适用人群类别</th>\n",
       "      <th>产品来源</th>\n",
       "      <th>登记年份</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>浙江海正苏立康生物科技有限公司</td>\n",
       "      <td>伊能佳®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20200009</td>\n",
       "      <td>2025-08-27</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉末</td>\n",
       "      <td>10岁以上特定疾病或者医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>51</td>\n",
       "      <td>广州纽健生物科技有限公司</td>\n",
       "      <td>普柔汀®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20200012</td>\n",
       "      <td>2025-10-27</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>52</td>\n",
       "      <td>吉林麦孚营养科技有限公司长春分公司</td>\n",
       "      <td>浦索®特殊医学用途蛋白质组件配方粉</td>\n",
       "      <td>国食注字TY20200013</td>\n",
       "      <td>2025-12-20</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>66</td>\n",
       "      <td>河北艾圣科技有限公司</td>\n",
       "      <td>诺葆平®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20210014</td>\n",
       "      <td>2026-04-11</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>78</td>\n",
       "      <td>江苏冬泽特医食品有限公司</td>\n",
       "      <td>冬泽定特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20220002</td>\n",
       "      <td>2027-04-05</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>98</td>\n",
       "      <td>亚宝药业集团股份有限公司</td>\n",
       "      <td>唯源泰®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230008</td>\n",
       "      <td>2028-02-23</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>108</td>\n",
       "      <td>爱优诺营养品有限公司</td>\n",
       "      <td>爱优诺优达力特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230018</td>\n",
       "      <td>2028-05-03</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>109</td>\n",
       "      <td>西安力邦临床营养股份有限公司</td>\n",
       "      <td>立如箐®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230019</td>\n",
       "      <td>2028-05-03</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>117</td>\n",
       "      <td>江中药业股份有限公司</td>\n",
       "      <td>初元安本®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230027</td>\n",
       "      <td>2028-06-15</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>123</td>\n",
       "      <td>鲲鱼健康药业江苏有限公司</td>\n",
       "      <td>嘉膳能特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230033</td>\n",
       "      <td>2028-07-10</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状。</td>\n",
       "      <td>10岁以上特定疾病或医学状态下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>129</td>\n",
       "      <td>山东若尧特医食品有限公司</td>\n",
       "      <td>若益特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230039</td>\n",
       "      <td>2028-08-28</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>132</td>\n",
       "      <td>无锡市恒益健康科技有限公司</td>\n",
       "      <td>恒益清元特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230042</td>\n",
       "      <td>2028-08-28</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>147</td>\n",
       "      <td>哈尔滨拜仑斯特临床营养有限公司</td>\n",
       "      <td>唯卡素®特殊医学用途蛋白质组件配方粉</td>\n",
       "      <td>国食注字TY20230056</td>\n",
       "      <td>2028-11-13</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>148</td>\n",
       "      <td>杭州纽曲星生物科技有限公司</td>\n",
       "      <td>海能博特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230057</td>\n",
       "      <td>2028-11-13</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>151</td>\n",
       "      <td>南京玉鹤鸣医学营养科技股份有限公司</td>\n",
       "      <td>科惠研特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230060</td>\n",
       "      <td>2028-11-13</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>153</td>\n",
       "      <td>江苏冬泽特医食品有限公司</td>\n",
       "      <td>冬泽力太特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230062</td>\n",
       "      <td>2028-11-13</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>155</td>\n",
       "      <td>山东若尧特医食品有限公司</td>\n",
       "      <td>若速特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230064</td>\n",
       "      <td>2028-12-14</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>156</td>\n",
       "      <td>南通励成生物工程有限公司</td>\n",
       "      <td>力优宜®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20230065</td>\n",
       "      <td>2028-12-14</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>166</td>\n",
       "      <td>山东立好特殊医学用途配方食品有限公司</td>\n",
       "      <td>咪素®特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20240007</td>\n",
       "      <td>2029-01-05</td>\n",
       "      <td>蛋白质（氨基酸）组件</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或者医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>176</td>\n",
       "      <td>广东君悦营养医学有限公司</td>\n",
       "      <td>君蓓清特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20240016</td>\n",
       "      <td>2029-02-08</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>粉状</td>\n",
       "      <td>10岁以上特定疾病或者医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>179</td>\n",
       "      <td>江苏冬泽特医食品有限公司</td>\n",
       "      <td>冬泽力亮特殊医学用途蛋白质组件配方食品</td>\n",
       "      <td>国食注字TY20240019</td>\n",
       "      <td>2029-04-01</td>\n",
       "      <td>非全营养配方食品</td>\n",
       "      <td>液态</td>\n",
       "      <td>10岁以上特定疾病或医学状况下需要补充蛋白质的人群。</td>\n",
       "      <td>1岁以上特医食品</td>\n",
       "      <td>国产产品</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                企业名称                   产品名称            注册证号  \\\n",
       "48           48     浙江海正苏立康生物科技有限公司    伊能佳®特殊医学用途蛋白质组件配方食品  国食注字TY20200009   \n",
       "51           51        广州纽健生物科技有限公司    普柔汀®特殊医学用途蛋白质组件配方食品  国食注字TY20200012   \n",
       "52           52   吉林麦孚营养科技有限公司长春分公司      浦索®特殊医学用途蛋白质组件配方粉  国食注字TY20200013   \n",
       "66           66          河北艾圣科技有限公司    诺葆平®特殊医学用途蛋白质组件配方食品  国食注字TY20210014   \n",
       "78           78        江苏冬泽特医食品有限公司     冬泽定特殊医学用途蛋白质组件配方食品  国食注字TY20220002   \n",
       "98           98        亚宝药业集团股份有限公司    唯源泰®特殊医学用途蛋白质组件配方食品  国食注字TY20230008   \n",
       "108         108          爱优诺营养品有限公司  爱优诺优达力特殊医学用途蛋白质组件配方食品  国食注字TY20230018   \n",
       "109         109      西安力邦临床营养股份有限公司    立如箐®特殊医学用途蛋白质组件配方食品  国食注字TY20230019   \n",
       "117         117          江中药业股份有限公司   初元安本®特殊医学用途蛋白质组件配方食品  国食注字TY20230027   \n",
       "123         123        鲲鱼健康药业江苏有限公司     嘉膳能特殊医学用途蛋白质组件配方食品  国食注字TY20230033   \n",
       "129         129        山东若尧特医食品有限公司      若益特殊医学用途蛋白质组件配方食品  国食注字TY20230039   \n",
       "132         132       无锡市恒益健康科技有限公司    恒益清元特殊医学用途蛋白质组件配方食品  国食注字TY20230042   \n",
       "147         147     哈尔滨拜仑斯特临床营养有限公司     唯卡素®特殊医学用途蛋白质组件配方粉  国食注字TY20230056   \n",
       "148         148       杭州纽曲星生物科技有限公司     海能博特殊医学用途蛋白质组件配方食品  国食注字TY20230057   \n",
       "151         151   南京玉鹤鸣医学营养科技股份有限公司     科惠研特殊医学用途蛋白质组件配方食品  国食注字TY20230060   \n",
       "153         153        江苏冬泽特医食品有限公司    冬泽力太特殊医学用途蛋白质组件配方食品  国食注字TY20230062   \n",
       "155         155        山东若尧特医食品有限公司      若速特殊医学用途蛋白质组件配方食品  国食注字TY20230064   \n",
       "156         156        南通励成生物工程有限公司    力优宜®特殊医学用途蛋白质组件配方食品  国食注字TY20230065   \n",
       "166         166  山东立好特殊医学用途配方食品有限公司     咪素®特殊医学用途蛋白质组件配方食品  国食注字TY20240007   \n",
       "176         176        广东君悦营养医学有限公司     君蓓清特殊医学用途蛋白质组件配方食品  国食注字TY20240016   \n",
       "179         179        江苏冬泽特医食品有限公司    冬泽力亮特殊医学用途蛋白质组件配方食品  国食注字TY20240019   \n",
       "\n",
       "          有效期至        产品类别 组织状态                         适用人群    适用人群类别  产品来源  \\\n",
       "48  2025-08-27  蛋白质（氨基酸）组件   粉末  10岁以上特定疾病或者医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "51  2025-10-27    非全营养配方食品   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "52  2025-12-20    非全营养配方食品   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "66  2026-04-11    非全营养配方食品   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "78  2027-04-05  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "98  2028-02-23    非全营养配方食品   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "108 2028-05-03  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "109 2028-05-03  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "117 2028-06-15  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "123 2028-07-10  蛋白质（氨基酸）组件  粉状。   10岁以上特定疾病或医学状态下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "129 2028-08-28  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "132 2028-08-28  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "147 2028-11-13  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "148 2028-11-13  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "151 2028-11-13    非全营养配方食品   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "153 2028-11-13    非全营养配方食品   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "155 2028-12-14  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "156 2028-12-14  蛋白质（氨基酸）组件   粉状   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "166 2029-01-05  蛋白质（氨基酸）组件   粉状  10岁以上特定疾病或者医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "176 2029-02-08    非全营养配方食品   粉状  10岁以上特定疾病或者医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "179 2029-04-01    非全营养配方食品   液态   10岁以上特定疾病或医学状况下需要补充蛋白质的人群。  1岁以上特医食品  国产产品   \n",
       "\n",
       "     登记年份  \n",
       "48   2020  \n",
       "51   2020  \n",
       "52   2020  \n",
       "66   2021  \n",
       "78   2022  \n",
       "98   2023  \n",
       "108  2023  \n",
       "109  2023  \n",
       "117  2023  \n",
       "123  2023  \n",
       "129  2023  \n",
       "132  2023  \n",
       "147  2023  \n",
       "148  2023  \n",
       "151  2023  \n",
       "153  2023  \n",
       "155  2023  \n",
       "156  2023  \n",
       "166  2024  \n",
       "176  2024  \n",
       "179  2024  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(df.str.contains('10岁以上'))&(df.str.contains('补充蛋白质'))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8414b8c9-9d48-42d2-88c8-0348f605b45b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
